UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cHiHVXjlKELDrRMcE/Hod+ROY0ZhvFRtLC0ri8Ww670='
WHERE
key_id = '0bef52354e94fa2f45880cda86d61a0c1438af789f01f18278958b7f948dda8f'
AND (
token = 'cHiHVXjlKELDrRMcE/Hod+ROY0ZhvFRtLC0ri8Ww670='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)