UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kVfrQU97+XvhbqOWDrHfWr+TcqxLUL+QUKyh6SiR874='
WHERE
key_id = 'b254c907769f2052541226809755bf7a82335cf7ec305d4f7a6ad645155d50bd'
AND (
token = 'kVfrQU97+XvhbqOWDrHfWr+TcqxLUL+QUKyh6SiR874='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)