UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Prur36a7YiId/11JZEns3MGkLt2kG1hbIelYfEp16kU='
WHERE
key_id = 'b38d8dd347dcd123564aacdc5b76830c1359d1375eca01270a457c3dbea84c9a'
AND (
token = 'Prur36a7YiId/11JZEns3MGkLt2kG1hbIelYfEp16kU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)