UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qLYeZoG1uqbqfKDwnF/bu0y8anf6kghkUdKfRI5z30o='
WHERE
key_id = 'dadca65f85de9f14d5841cb5c183a2a6202f7f8bfc845bc777163c6b2aad9c2c'
AND (
token = 'qLYeZoG1uqbqfKDwnF/bu0y8anf6kghkUdKfRI5z30o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)