UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Q8lh6Be03pirKZdJ1QFPpinSncGG2Rey0ARxSxZT3Gk='
WHERE
key_id = 'd87884a0566e2657218000526bfc3ed5d464b83aee276a6658882fe7d56c647d'
AND (
token = 'Q8lh6Be03pirKZdJ1QFPpinSncGG2Rey0ARxSxZT3Gk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)