UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8SVRO8bE8J2D9X55/BSBbP/uTXHQukDdzfmaZnq+2Tw='
WHERE
key_id = '7af774d1517bdcb0189972c0014e33ab769bf117b728c1f8b99a91eba661b593'
AND (
token = '8SVRO8bE8J2D9X55/BSBbP/uTXHQukDdzfmaZnq+2Tw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)