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