UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IiXWwzKqGFqUOKuUWMvAur55ECAUf717/3RBa70Un8Y='
WHERE
key_id = '06c8cda72d1434be80d558f45505b621f55488d07c80534cb5dfc68623ae8571'
AND (
token = 'IiXWwzKqGFqUOKuUWMvAur55ECAUf717/3RBa70Un8Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)