UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HnAR6gIR6TzVDWnsFOohO1BijMN2TEF2GVRVk6d4lCQ='
WHERE
key_id = '3ca21360c6017d61002eff3456c367658c23d06d21a446b1a4b19dfd04cea2b6'
AND (
token = 'HnAR6gIR6TzVDWnsFOohO1BijMN2TEF2GVRVk6d4lCQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)