UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wZBa4IX5DpaKMLQjIKW7FP8Ib4sFZHsac4HX5DqmEm4='
WHERE
key_id = '507ed6bb4d40fdbbc886634c71e225911ec5bf1685a8c57b9e9d297679683230'
AND (
token = 'wZBa4IX5DpaKMLQjIKW7FP8Ib4sFZHsac4HX5DqmEm4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)