UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Dc3HUcIfDPjo83zZ8JEtkiosFJXU1fHeM19ctf81aAc='
WHERE
key_id = '9b16f718f2666f6cb84147e7f8d190fddfda3fe2d156ca72a09eec860e0535e9'
AND (
token = 'Dc3HUcIfDPjo83zZ8JEtkiosFJXU1fHeM19ctf81aAc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)