UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3HBRoYKvxjCl4T9R3phBGJwLU2drndGbfkW0Fs1ZKmo='
WHERE
key_id = '2142612efa8e9ffddae89ad3c3a04bde93735a79b463829413195b27cb4312ab'
AND (
token = '3HBRoYKvxjCl4T9R3phBGJwLU2drndGbfkW0Fs1ZKmo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)