UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LXB49gn8KH3arZb1ccSnv8UiisHiZwR4q8TnoqYwddw='
WHERE
key_id = '49ec7a397de4e46236cdcae96d7fa6829494971c494abb0a1d13c1b3a7624e6b'
AND (
token = 'LXB49gn8KH3arZb1ccSnv8UiisHiZwR4q8TnoqYwddw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)