UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W0G0CbEE6Rkh8nDOjdaZ7fvsK1PeDzpShvcoI4L13Hc='
WHERE
key_id = '4530c546f118fd2281f15ec994216385610717ece28fc645be2a3e128beed6cb'
AND (
token = 'W0G0CbEE6Rkh8nDOjdaZ7fvsK1PeDzpShvcoI4L13Hc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)