UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tJTjI74A39HIGceVrYHI4i19SkN9nLFAfhPJd96T8IE='
WHERE
key_id = '2caca47f40a2c0281f1f3024397b6efdba608af7e74c351a554fd56dd5a34b2d'
AND (
token = 'tJTjI74A39HIGceVrYHI4i19SkN9nLFAfhPJd96T8IE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)