UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BK4BbIqOx0Da+Y1oVJ0TQne9O26lQq77jWfWAkYm+zk='
WHERE
key_id = 'a98ab671cad3ee7d2d8bd9f4ab9b075855f9cabf8c04558031f371b925136c1f'
AND (
token = 'BK4BbIqOx0Da+Y1oVJ0TQne9O26lQq77jWfWAkYm+zk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)