UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5PsMRq4O9oiJqhLrml3NynIxHI9XY32jW1fKQVNcjIY='
WHERE
key_id = '1afd42bb18033e373a88e90aabbf4045913aef4b812302ff5b2ce56c6c529c6f'
AND (
token = '5PsMRq4O9oiJqhLrml3NynIxHI9XY32jW1fKQVNcjIY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)