UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xr4EV2MlQLsOUd8eI1Hos1I178yN+SRqEsVmg0U9xh4='
WHERE
key_id = 'ccddb02f340253f844b3a452b54de44e133d66e2fc586dad379ac47403013e57'
AND (
token = 'Xr4EV2MlQLsOUd8eI1Hos1I178yN+SRqEsVmg0U9xh4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)