UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bDQiVGvTVCNVin3y87WAGgm/k9wGv8JNDNE1KSLhsKY='
WHERE
key_id = '3578b1123476111699d64e1dece1ee7d4dbf82d96437a1abf0ace5531a2da924'
AND (
token = 'bDQiVGvTVCNVin3y87WAGgm/k9wGv8JNDNE1KSLhsKY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)