UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pxgDdj9ZNaBFBLAwy4qQm1BugXLnaBVhSF12tvHk9n0='
WHERE
key_id = 'eb316aaae16b46d3044149210a5bb22f7a8708c2fe2446092d03a196cbc2418e'
AND (
token = 'pxgDdj9ZNaBFBLAwy4qQm1BugXLnaBVhSF12tvHk9n0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)