UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZPBNKajTF/mx1Uj2d6D17LGJMQsIcR05tPnWLJHOzUE='
WHERE
key_id = '7f9c145350d1246b46d7909ae757988d68ebd7648a57c6c13dea61c1673b11f2'
AND (
token = 'ZPBNKajTF/mx1Uj2d6D17LGJMQsIcR05tPnWLJHOzUE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)