UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nKffKDoAnVsCl7aeCrWk22Dt94b+I2/+IhZ05erVM7M='
WHERE
key_id = 'dfac2196b18b83ebcfb84406dd07c2a88b7b4648a0f372327e5d6fc09fe030df'
AND (
token = 'nKffKDoAnVsCl7aeCrWk22Dt94b+I2/+IhZ05erVM7M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)