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