UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MjNkzl80Qwji9IK5DCB8IFWlRBw0FT90udF02xDqKNg='
WHERE
key_id = '8d3618388c4fe590ee62f63740928bcf494482976ab662161f8ae4b15c4bf3ec'
AND (
token = 'MjNkzl80Qwji9IK5DCB8IFWlRBw0FT90udF02xDqKNg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)