UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bYns6pIhUHkYRnKI2Dubod+y/Ad0CujTG5aIZh4+EKI='
WHERE
key_id = '6a54938e39b2025cfa548ad89de44b34f6eaa3963b61612651a3939afca01c3e'
AND (
token = 'bYns6pIhUHkYRnKI2Dubod+y/Ad0CujTG5aIZh4+EKI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)