UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8z4/W4tEANU8zhuHZF5EwQgfI7qlRwrraVms04YRggg='
WHERE
key_id = '5b3338977b65f5df56a78a4868ed9d1cdc4bd1e291fff80662a7ffd43596a4bd'
AND (
token = '8z4/W4tEANU8zhuHZF5EwQgfI7qlRwrraVms04YRggg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)