UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3l7n8WlzLDPItszOabxp7Wx1gksja4YZHOSWqEg1Vu4='
WHERE
key_id = 'a562a4badfff5afedc782c4f5bb1c2af483438c1024131be60c82e46df41a910'
AND (
token = '3l7n8WlzLDPItszOabxp7Wx1gksja4YZHOSWqEg1Vu4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)