UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J/DQbS3kUXzEjdgNfkUbeexgH3tMYlWlscO9+wo6qI0='
WHERE
key_id = '87171e0f4302f86ac3b7d99284f6f110a921b2b6b6d31941b29abd7f73fce8a4'
AND (
token = 'J/DQbS3kUXzEjdgNfkUbeexgH3tMYlWlscO9+wo6qI0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)